package com.first.teacher.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.first.common.pojo.EduCourse;
import com.first.common.pojo.EduTeacher;
import com.first.common.pojo.TbShoucangCourse;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ShouCangCourseMapper extends BaseMapper<TbShoucangCourse> {
    @Select("SELECT ec.* FROM edu_course ec JOIN tb_shoucang_course tsc ON tsc.course_id=ec.id WHERE\n" +
            " tsc.member_id=#{id}")
    List<EduCourse> findFavoriteCourseById(String id);



}
